package kr.or.kosta.otr.persistence.score;

import java.sql.SQLException;
import java.util.ArrayList;

import kr.or.kosta.otr.vo.ScoreVO;

//전부 인자 값 이해 안감....
//기업ID를 이용해야 될 것 같은데? 아님 더 필요하거나 이해안감
//시퀀스(고유id)/승진기회및가능성/복지및급여/사내문화/휴가자율성/경영진/초과근무
public interface ScoreDao {
	void writeScore(ScoreVO scoreVo)throws SQLException;
	void deleteScore(int scoreId)throws SQLException;
	ScoreVO getAllScore(int scoreId)throws SQLException;
	ArrayList<Integer> getAllCompanyOrderByPromotion()throws SQLException;
	ArrayList<Integer> getAllCompanyOrderByWelfare()throws SQLException;
	ArrayList<Integer> getAllCompanyOrderByCulture()throws SQLException;
	ArrayList<Integer> getAllCompanyOrderByHoliday()throws SQLException;
	ArrayList<Integer> getAllCompanyOrderByExecutive()throws SQLException;
	ArrayList<Integer> getAllCompanyOrderByOverdue()throws SQLException;
	float getCompanyScoreTotal(int companyId)throws SQLException;
	void updateTotalScore(int scoreId) throws SQLException; 
	float getTotalScoreOfChance(int companyId) throws SQLException;
	float getTotalScoreOfWelfare(int companyId) throws SQLException;
	float getTotalScoreOfCulture(int companyId) throws SQLException;
	float getTotalScoreOfHoliday(int companyId) throws SQLException;
	float getTotalScoreOfExecutive(int companyId) throws SQLException;
	float getTotalScoreOfOverdue(int companyId) throws SQLException;
	float getTotalScoreOfTotal(int companyId) throws SQLException;
	
}
